Part I. Computation of Community Completeness scores: The selected POIs (amenities) include park, convenience, restaurant, supermarket, library, wastewater plant. The selected time lengths for travel include 5, 10, and 15 minutes. The value of amenity preference are predetermined to be 0.7, 1.0, 0.5, 0.9, 0.8, 0.01 for park, convenience, restaurant, supermarket, library, wastewater plant, respectively. The corresponding amenity quantity are 2, 5, 30, 1, 1, 0. The decay function for amenity is assumed to be y = -log(0.5)/(amenity quantity). The analyses are as follows. 1. Map for all Points of Interest (POIs) in San Mateo County 2. Map (in block groups) for the selected 6 POIs for San Mateo County 3. Map for Redwood City block groups 4. Map of total, walking, cycling, and driving normalized completeness scores for selected POIs 5. Geographical comparison across sub-regions in Redwood City for total, walking, cycling, and driving normalized completeness scores 6. Comparison of completeness scores and percentages of scores over baseline (i.e. value >1 ) for including negative (unwanted) amenity and excluding essential (necessary) amenity in the communities of Redwood city (i.e. Wastewater plant is considered as a negative amenity for this case; whereas, the convenience stores is an essential amenity) 7. Geographical (sub-regions) comparison of completeness scores and percentages of scores over baseline for including negative amenity and excluding essential amenity in the communities of Redwood City. Part II. Equity analysis – population comparison by race using 2020 decennial census data 1. Map of Redwood City (blocks) within 5 min walking to POIs 2. Population comparison by race for San Mateo County vs. Redwood City within 5 min walking to POIs 3. Population comparison by race for Redwood City vs. Redwood City within 5 min walking to POIs Part III. The analyses (in blocks) of NHTS data were performed individually for geographical comparison of travel pattern among three regions: Bay area, San Mateo county and Redwood City. The analytical contents are as follows. 1. CBSAS map 2. Travel patterns for trip frequency, mileages, and duration(time length) by trip mode and trip purpose

PART I

## Reading layer `gis_osm_pois_a_free_1' from data source 
##   `/Volumes/GoogleDrive/Shared drives/SFBI/Data Library/OSM/gis_osm_pois_a_free_1.shp' 
##   using driver `ESRI Shapefile'
## Simple feature collection with 78819 features and 4 fields
## Geometry type: MULTIPOLYGON
## Dimension:     XY
## Bounding box:  xmin: -124.3564 ymin: 35.78716 xmax: -115.647 ymax: 42.00657
## Geodetic CRS:  WGS 84

Map for Points of Interest (Amenities) in San Mateo County

Map for selected Points of Interest (Amenities) in San Mateo County

Map for Redwood City block groups

Map of “total” completeness scores for selected POIs in Redwood City – The total (normalized) completeness scores are all above 1. The center part of Redwood City has the highest total completeness scores over 2.6. The outer parts have lower scores around 2, especially the south western area.

Map of “walking” completeness scores for selected POIs in Redwood City – For walking, the center part of Redwood City has the total completeness score close to 1. The rest of the areas have lower scores below 1, especially the south western and north eastern areas.

Map of “cycling” completeness scores for selected POIs in Redwood City – For cycling, the center part of Redwood City has the total completeness score around 1.5. The outer areas have lower scores below 1, especially the south western and north eastern areas.

Map of “driving” completeness scores for selected POIs in Redwood City – The driving completeness scores are all above 1. The center part of Redwood City has the highest driving completeness scores over 2.6. The outer parts have lower scores around 2, and the lowest especially in the south western area.

## List of 3
##  $ legend.position : chr "bottom"
##  $ legend.direction: chr "vertical"
##  $ fill            :List of 21
##   ..$ title         : list()
##   .. ..- attr(*, "class")= chr "waiver"
##   ..$ title.position: NULL
##   ..$ title.theme   : NULL
##   ..$ title.hjust   : NULL
##   ..$ title.vjust   : NULL
##   ..$ label         : logi TRUE
##   ..$ label.position: NULL
##   ..$ label.theme   : NULL
##   ..$ label.hjust   : NULL
##   ..$ label.vjust   : NULL
##   ..$ keywidth      : NULL
##   ..$ keyheight     : NULL
##   ..$ direction     : NULL
##   ..$ override.aes  : Named list()
##   ..$ nrow          : NULL
##   ..$ ncol          : NULL
##   ..$ byrow         : logi FALSE
##   ..$ reverse       : logi TRUE
##   ..$ order         : num 0
##   ..$ available_aes : chr "any"
##   ..$ name          : chr "legend"
##   ..- attr(*, "class")= chr [1:2] "guide" "legend"
##  - attr(*, "class")= chr [1:2] "theme" "gg"
##  - attr(*, "complete")= logi FALSE
##  - attr(*, "validate")= logi TRUE

## List of 3
##  $ legend.position : chr "bottom"
##  $ legend.direction: chr "vertical"
##  $ fill            :List of 21
##   ..$ title         : list()
##   .. ..- attr(*, "class")= chr "waiver"
##   ..$ title.position: NULL
##   ..$ title.theme   : NULL
##   ..$ title.hjust   : NULL
##   ..$ title.vjust   : NULL
##   ..$ label         : logi TRUE
##   ..$ label.position: NULL
##   ..$ label.theme   : NULL
##   ..$ label.hjust   : NULL
##   ..$ label.vjust   : NULL
##   ..$ keywidth      : NULL
##   ..$ keyheight     : NULL
##   ..$ direction     : NULL
##   ..$ override.aes  : Named list()
##   ..$ nrow          : NULL
##   ..$ ncol          : NULL
##   ..$ byrow         : logi FALSE
##   ..$ reverse       : logi TRUE
##   ..$ order         : num 0
##   ..$ available_aes : chr "any"
##   ..$ name          : chr "legend"
##   ..- attr(*, "class")= chr [1:2] "guide" "legend"
##  - attr(*, "class")= chr [1:2] "theme" "gg"
##  - attr(*, "complete")= logi FALSE
##  - attr(*, "validate")= logi TRUE

Geographical comparison across sub-regions in Redwood city for total, walking, cycling, and driving normalized completeness scores – Scores for total, walking, cycling, and driving vary significantly across sub-regions in Redwood city, especially for walking and cycling.

Comparison of completeness scores for including wastewater plant (negative amenity) and excluding convenience store (essential amenity) in Redwood city

As the wastewater plant is included in the community, the completeness scores almost remain the same. This may imply that people do not care for the wastewater plant as a negative amenity. It may also imply that to use the wastewater plant as a negative amenity for the case is not appropriate. Other negative amenities may be considered instead. However, for the essential amenity (convenience store), is excluded from the community, the scores significantly dropped. For region percentages with scores over baseline only significantly dropped for walking and cycling, but not for driving since people can drive farther for convenience store and therefore the community completeness scores can still remain above the baseline.

Geographical (sub-regions) comparison of completeness scores and percentages of scores over baseline for including negative amenity and excluding essential amenity in the communities of Redwood city

There is no significant difference in completeness scores for walking between communities with and without wastewater plant (negative amenity).

There is no significant difference in completeness scores for cycling between communities with and without wastewater plant (negative amenity).

There is no significant difference in completeness scores for driving between communities with and without wastewater plant (negative amenity).

There is no significant difference in completeness scores for total between communities with and without wastewater plant (negative amenity).

The walking completeness scores for communities with convenience store are much higher than without the convenience store (essential amenity).

The cycling completeness scores for communities with convenience store are much higher than without the convenience store (essential amenity).

The driving completeness scores for communities with convenience store are much higher than without the convenience store (essential amenity).

The total completeness scores for communities with convenience store are much higher than without the convenience store (essential amenity).

#PART II Equity Analysis – population comparison by race using 2020 decennial census data)

Map of Redwood City (blocks) within 5 (min) walking isochrone

## 0.1198675 [1]

Population comparison by race for San Mateo County vs. Redwood City POI isochrones within 5 min walking

There is a lower percentage of Asia alone living in Redwood City within 5 min walking isochrone than San Mateo County. However, higher percentages for White alone and Some Other Race alone are living in Redwood City within 5 min walking isochrone as compared to the San Mateo County.

Redwood City population by race vs. Redwood City within 5 min walking to POIs

## 0.9603958 [1]

The racial distribution in the Redwood City within 5 min walking isochrones is the same as the full areas in the Redwood City.

PART III.

Travel Pattern Analysis of NHTS data

Travel Pattern Analysis for Bay area – CBSAS map

## # A tibble: 24 × 2
##    VALUE LABEL                                     
##    <dbl> <fct>                                     
##  1    -9 Not ascertained                           
##  2    -8 I don't know                              
##  3    -7 I prefer not to answer                    
##  4    -1 Appropriate skip                          
##  5     1 1. Regular home activities (chores, sleep)
##  6     2 2. Work from home (paid)                  
##  7     3 3. Work                                   
##  8     4 4. Work-related meeting / trip            
##  9     5 5. Volunteer activities (not paid)        
## 10     6 6. Drop off /pick up someone              
## # … with 14 more rows
## # A tibble: 25 × 2
##    VALUE LABEL                 
##    <dbl> <fct>                 
##  1    -9 Not ascertained       
##  2    -8 I don't know          
##  3    -7 I prefer not to answer
##  4    -1 Appropriate skip      
##  5     1 Walk                  
##  6     2 Bicycle               
##  7     3 Car                   
##  8     4 SUV                   
##  9     5 Van                   
## 10     6 Pickup truck          
## # … with 15 more rows

People in Bay Area tend to travel mostly by cars, followed by SUV, walking and van. The trip purposes are mostly regular home activities, followed by buying goods, work and dropping off/picking up someone.

For trip frequency over half million, the major travel purpose becomes buying goods, followed by work and then dropping off/picking up someone. People tend to travel mostly by cars still, followed by walking, and then SUV.

Some trip modes such as airplane, Amtrak/Commuter rail or subway/elevated/light rail/street car have longer duration times. Mostly the duration times are between 10~20 minutes. For example, specifically, for walking to work, the duration is 10 (min). For cycling to work, the duration is 20 (min). For driving to work with car, the duration is 22 (min). For buying goods, the duration times are 10, 12, 10 (min) for walking, cycling, and driving, respectively, which can be used as the reference for the reasonable duration time in computing the community completeness score accordingly.

The percentage of trips for Buying goods with car is the highest, followed by work with car and then dropping off/picking up someone with car.

Except that airplane travel for the purpose of changing type of transportation has the highest mileages, work and buying goods with car have the greatest trip mileages among others. Buying meals, visiting friends/relatives, dropping off/picking up someone, recreational activities with car are the next category with the higher mileages.

Car traveling have the highest percentages in terms of the mileages after Home-allocated/Airplane trips were removed. For traveling purpose, buying goods and work have equally high percentages in travel mileages, followed by visiting friend/relatives and buying meals, and then, dropping off/picking up someone, attending school and recreational activities.

Travel Pattern Analysis for San Mateo County

## Simple feature collection with 1 feature and 9 fields
## Geometry type: MULTIPOLYGON
## Dimension:     XY
## Bounding box:  xmin: -122.5209 ymin: 37.10732 xmax: -122.1152 ymax: 37.70843
## Geodetic CRS:  NAD83
##   STATEFP COUNTYFP COUNTYNS       AFFGEOID GEOID      NAME LSAD      ALAND
## 1      06      081 00277305 0500000US06081 06081 San Mateo   06 1161957020
##      AWATER                       geometry
## 1 757114175 MULTIPOLYGON (((-122.5209 3...

San Mateo County CBSAS map

Similar to the case in Bay area, People in San Mateo County travel mostly by cars, followed by SUV, walking and van. The trip purposes are mostly regular home activities, followed by buying goods, work and dropping off/picking up someone.

Same as in the case of Bay area, for trip frequency over half million, the major travel purpose is still buying goods, followed by work and then dropping off/picking up someone. The order for travel mode is also cars > walking > SUV.

Similar to the case of Bay area, the duration times remain to be between 10~20 minutes. For work, the duration is 9, 20, 23 (min) for walking, cycling, and driving, respectively. For buying goods, the duration times are also 10, 14, 10 (min) for walking, cycling, and driving, respectively.

Same as in the Bay area, the percentage of trips for Buying goods with car is the highest, followed by work with car and then dropping off/picking up someone with car.

Similar results were obtained here as for Bay area that work and buying meals with car have the greater trip mileages among all except for the airplane trips. Visiting friends/relatives, recreation activities, buying goods, dropping off/picking up someone with car are the next category with the higher mileages.

Same as in the Bay area, car traveling still have the highest percentages in terms of the mileages after Home-allocated/Airplane trips were removed. For traveling purpose, work have the exactly high percentage of the mileage as in the Bay area. Buying meals, dropping off/picking up someone, buying goods, recreational activities, visiting friends/relatives is the category with the second highest percentages. However, different from the Bay area, the percentages in San Mateo County for buying goods and attending school are much lower.

Travel Pattern Analysis for Redwood City

Redwood City CBSAS map

Similar to the case in Bay area and San Mateo County, people in Redwood City also travel mostly by cars, followed by SUV or walking, and then, van. The trip purposes are mostly regular home activities, followed by buying goods, work and dropping off/picking up someone.

Same as the cases of Bay area and San Mateo, for trip frequency over half million, the major travel purpose is still buying goods, followed by work and then dropping off/picking up someone. The order for travel mode is also cars, followed by walking or SUV depending on trip purposes.

Similar to the case of Bay area and San Mateo, the duration times remain to be between 10~20 minutes. For work, the duration is exactly the same as in San Mateo County which is 9, 20, 23 (min) for walking, cycling, and driving, respectively. For buying goods, the duration times are also 10, 14, 10 (min) for walking, cycling, and driving, respectively.

Same as in the Bay area and San Mateo County, the percentage of trips for Buying goods with car is the highest, followed by work with car and then dropping off/picking up someone with car.

Similar results were obtained here as for Bay area and San Mateo County that work and buying meals with car have the greater trip mileages among all except for the airplane trips. Visiting friends/relatives, recreation activities, buying goods, dropping off/picking up someone with car are the next category with the higher mileages.

Same as in the Bay area and San Mateo county, car traveling still have the highest percentages in terms of the mileages after Home-allocated/Airplane trips were removed. For traveling purpose, work have the exactly high percentage of the mileage as in the Bay area and San Mateo County. Buying meals, dropping off/picking up someone, buying goods, recreational activities, visiting friends/relatives is the category with the second highest percentages. Both Redwood City and San Mateo County has much lower percentages of mileages for buying goods and attending school, which is different from Bay area.

Generall Conclusion

The Pros: 1. As we do the geographical comparison of travel patterns for Bay area, San Mateo County and Redwood City with different sizes, we found that their travel patterns are pretty much homogeneous. The general findings show that people travel mostly by car (or SUV/ van) and walking. However, we do not see too much cycling from the data. If excluding home activities as discussing about the transportation, the trip purposes are mostly buying goods, work and dropping off/picking up someone. The time lengths of travel are 9, 20, 23 for walking, cycling, and driving, respectively. These estimates are pretty close across three regions we inspected, and therefore, can be used as the reasonable duration, which is really important for trying to come up with less biased estimation in computing the community completeness scores. 2. The community completeness can be assessed with this approach which can served as good reference for community planing and development. The inclusion of certain amenities (negative or essential) can be evaluated ahead of development for the regions to reduce the potential risks from inappropriate planning.

The cons: 1. Differences may exist between geographic regions. For example, both Redwood City and San Mateo County has much lower trip percentages for buying goods and attending school, which is different from Bay area. This part of finding is critical for practitioners in the related planning and development business. However, the findings from the methodology may not be generalized for all cases. Moreover, the findings provided by the survey may have some time lag as the information is obtained and the potential bias may be expected due to the possible rapid change of travel patterns over time. 2. The evaluation of community completeness involved with subjective viewpoints to certain degree which may lead to potential inappropriate decision making in planning.